SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567511 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567511 [ RunTime:0.002738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448977,366050,66773,319022,785101,420423,533304,630141,47870,300079,487396,812515,21309,870735,182200,24567,463030,827977,1031021,638576,882622,285988,901529,634849,475137,9597,168354,774483,403776,159692,1000430,544599,269541,910243,531565,867645,412558,388432,586063,566670,178915,429839,938634,811245,345065,878659,121291,967964,350657,861810,589709,336761,485043,875544,180559,399398,43466,211259,727603,553886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]