SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451970 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451970 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899048,463959,888426,389355,474989,106882,464176,872838,238420,594607,387231,924350,373042,2850,632499,929634,938975,210844,158559,1017275,439237,542185,659407,162188,495506,991308,262031,198835,893074,1047667,734677,478338,914732,277572,405924,568699,652594,784411,73376,573994,600777,564522,18975,905767,44032,243895,801566,849484,964724,860143,274892,1017322,923915,624,858141,894550,575999,581488,866883,627610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]