SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 718101 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 718101 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284398,1002421,1005011,168281,341581,573026,491840,338344,489398,494232,566378,332760,776091,307051,54081,681617,480618,889689,131145,381060,602116,425438,253676,345507,744358,738111,835368,716584,688148,311841,1003960,252524,814276,712860,140075,3557,761604,15747,243038,233336,375119,477439,746467,541516,574027,859208,916457,10342,64241,836071,964903,1015251,907289,798675,59886,834507,580193,501631,449665,106665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 718101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 718101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003190s ]