SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467241 LIMIT 1 [ RunTime:0.001776s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467241 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708818,178992,491590,436312,114524,736900,16758,252828,405548,232251,162866,1015097,668864,107291,745903,561101,1017035,291251,463024,157381,174796,892413,886162,563904,39983,659487,497183,917345,829266,565107,335232,20644,55700,919051,293654,281101,511215,279504,672167,403425,303428,84102,731070,1040035,566331,94852,1005713,366618,1021389,527244,630607,46450,194578,113660,495022,101089,397524,680026,686682,419508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]