SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014200 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014200 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946552,911299,681076,160708,954203,569300,311414,60122,967265,327325,900730,832117,346880,826500,833226,504891,687413,987134,942571,332342,720920,509645,426210,546627,780252,317938,104452,30221,94801,127600,326103,896783,1013801,1040938,16865,469970,598714,225288,980952,688462,415999,960682,294864,159657,486391,411501,837538,663123,977391,561837,195560,505729,390433,1046433,493884,238321,335521,723045,516096,1018032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]