SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001519s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803512 LIMIT 1 [ RunTime:0.002429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803512 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944392,368086,409164,310918,463130,21412,1023698,795447,985390,367765,745656,362185,242301,1034305,750104,917303,756881,230798,89602,591536,934006,800336,1044917,160951,278337,1027117,455948,557005,1006145,380746,427072,141809,897782,84723,684586,739858,794056,630647,285861,45890,443743,1012949,887849,253195,576043,35575,997105,100378,797445,575109,1005817,921887,553343,938488,724118,546545,615443,160241,290124,839426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000862s ]