SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491012 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491012 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495796,409268,685823,868048,374117,120072,78850,1033981,940917,197058,398623,128839,84715,538970,16824,517298,782233,743882,786638,38568,527844,991097,130888,925354,824645,12801,366827,634972,475411,1023709,108393,994168,294443,1032890,988792,497914,690082,400727,354478,730714,974107,65790,688307,297990,149657,948343,239333,363828,19876,106880,356040,339571,764993,537464,595808,590698,42729,368163,299553,682092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002254s ]