SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001673s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 173912 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 173912 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402799,1038673,1013782,640876,703503,179710,609703,1026338,156125,777121,751637,711880,637276,78633,996240,110566,612793,11352,362990,446229,580507,653365,548168,114108,809975,371674,568701,385412,823423,17381,144933,646640,220709,600570,539218,567418,841432,410118,954925,466648,981765,185699,454476,686102,10869,273223,456765,688765,399029,655985,820263,349980,66104,140894,510233,304208,950269,354912,471601,759660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 173912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 173912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]