SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027547 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027547 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402429,163782,705178,844878,598698,535940,1024567,134006,189560,1001769,80650,503538,1048547,245196,624148,1006937,119952,579379,732126,211786,71600,1035088,349857,286731,901716,859860,232840,815142,171564,951280,435606,699552,23189,408750,6013,328211,556764,149962,342606,913294,778917,31357,702161,802233,191370,552175,13769,30911,262187,114369,893452,313464,52752,469900,349516,117670,843890,866459,56555,162426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027547 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027547 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]