SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50753 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50753 [ RunTime:0.002245s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923042,675096,403849,690701,344509,698335,719510,164572,340029,807988,853096,127914,311873,378394,746837,241988,849753,846183,91065,569099,365214,225760,13124,540568,1033738,1002419,843861,69887,98892,894501,851253,315744,385344,375698,179396,249138,619678,856788,950308,9915,588640,265872,652277,234937,414139,523668,638672,313239,254012,564270,271978,582169,403467,972295,256366,963635,891578,607526,296255,189058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]