SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002974s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545963 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545963 [ RunTime:0.001410s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529510,634505,542515,707213,421490,952362,5361,184338,682828,930050,942900,836046,72913,829890,69495,887955,119761,1034477,297903,574258,911022,90457,182698,935691,586597,600571,245641,602142,957067,518156,819153,192886,532893,735572,382892,1000016,884438,100469,25866,683253,321680,999134,770014,553452,293109,370402,713666,858101,780981,90999,539461,264836,398166,150273,48521,101282,458327,320381,456729,453458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]