SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545221 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545221 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191329,890572,752230,318105,212299,547579,985156,167017,26778,538671,35618,409722,374844,467154,983338,47041,455751,15460,205187,322613,660569,424742,934914,65149,1035574,984953,163937,509398,273595,119557,1005773,431180,47679,663897,648443,142275,714061,23686,325818,334645,395334,147335,926091,904262,226578,159186,187217,966886,359612,571296,354655,504367,291520,398493,491784,987471,364219,718081,272249,975234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]