SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318023 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318023 [ RunTime:0.003233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395346,795845,424680,141063,42297,781656,415605,1024811,721718,984281,756977,93125,221980,205200,304418,383116,361613,404718,41840,25071,630983,448012,15505,199284,503153,67024,939132,288797,28172,336634,760531,141494,292115,163275,1042278,484154,411011,951372,1048807,340662,664511,306835,814803,144762,222621,481426,960073,410313,884432,427735,770188,33198,856094,37836,989953,189903,112668,747655,501016,989269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]