SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004988s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511965 LIMIT 1 [ RunTime:0.004496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511965 [ RunTime:0.003385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357424,621160,440891,1001822,760371,993803,424344,414331,918893,145404,811989,486641,683563,863519,752009,95744,239708,491354,399815,634418,758204,533180,432508,490372,28698,38639,834367,401629,32233,865930,545071,24170,313326,190685,426247,515398,697729,395042,214535,564944,324997,753348,923226,1046508,265780,1026021,368509,454128,971980,80683,96821,114818,122125,822902,984182,258552,985803,299652,697800,494745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001842s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511965 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000907s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511965 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]