SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048001 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048001 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803315,445286,865080,360862,90149,805840,395785,401822,894415,224808,465932,988386,760232,140451,823064,276101,444274,404700,205831,341712,281424,530841,223040,119228,223993,90728,699721,317267,676902,52603,584294,147647,984987,598392,791140,74744,517624,761803,258086,655675,752524,689066,900035,30887,10580,461503,128369,801190,464165,997296,127678,985216,749647,745561,928473,858098,551549,1007938,289199,782193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]