SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285007 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285007 [ RunTime:0.002258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654263,583791,979580,622622,314104,16501,682198,150222,752452,27703,274391,681285,450070,754616,812594,785857,448354,740665,833525,489201,778646,687943,493176,9842,808275,588664,1021396,294221,25265,706244,362906,493878,974186,30490,140042,830379,473550,375151,260047,424319,184373,245091,562724,1000325,112682,827632,1043308,843624,379850,383489,454304,149615,977953,100232,961318,701540,974926,314446,794189,374074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]