SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039158 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039158 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025640,59380,820714,164074,701534,799485,602890,210599,902960,36297,866864,546431,790187,698350,64639,939452,670877,256063,945480,67950,281052,213626,148932,415187,26902,125468,464238,49157,146596,182530,132917,5727,984925,96175,1005081,455071,599335,1021937,228870,254350,332702,513973,146044,673662,12338,162352,682029,568778,79031,395461,900347,64984,537340,916720,489204,490621,657743,877642,786577,631638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]