SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014428 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014428 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982686,679512,761856,200469,731798,842707,508273,129732,386828,207538,580516,115902,801188,350270,386374,956384,774389,727136,801611,580644,28681,509673,596338,272106,316176,56730,841246,145604,888771,508543,791895,879046,791604,242727,179573,593160,921841,852896,241503,290563,517071,478918,724218,703012,1012577,260989,326285,575310,375394,100029,403651,101948,729136,469109,959783,646316,257880,440922,725240,382159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]