SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203189 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203189 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100248,996647,478829,977352,999195,905035,64058,298938,888735,464906,931339,924754,575335,451480,242883,348853,598927,668910,668718,390196,11917,303083,170312,669849,999675,614239,345216,674403,1032997,294923,430630,157159,116302,293314,492063,1003342,28017,876832,376635,315999,181810,968304,968197,773129,712603,559940,920237,618575,241201,148516,184517,242780,874373,939783,258170,90843,349958,15569,305577,680833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]