SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495804 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495804 [ RunTime:0.003512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39852,672657,871784,712238,471678,1000072,717840,884136,729382,975915,514901,695185,639412,850153,532929,867838,212833,954417,166450,3428,116120,573389,645744,692594,154025,548018,280104,19620,45992,871695,562230,836772,765286,480119,110376,624884,4566,906805,665799,472638,618639,819739,583286,146596,463732,348305,14817,820097,205525,859541,907436,226050,162508,156464,349698,150883,913283,900661,191953,934788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]