SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003052s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 651009 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 651009 [ RunTime:0.003186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595055,204144,337687,615436,211071,429790,474084,158443,242605,723093,104618,12564,300892,938485,1407,106479,221414,261120,140934,193746,979735,295036,30194,779883,1045543,132253,618280,850767,380250,117265,761569,506323,889597,701923,324908,236496,450643,501225,927764,503560,539742,809810,864609,64340,81673,342755,189908,999381,315209,652878,1027160,51093,397893,682190,553544,750318,209455,657551,845790,325463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 651009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 651009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]