SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455078 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455078 [ RunTime:0.002488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738039,39456,295218,557597,423924,46191,403713,720270,234719,871982,225107,871950,848817,383639,481434,789796,613765,487192,139483,50758,597992,399461,1022685,665124,834318,328093,638001,50252,602252,457016,645364,273688,64202,1004174,691719,596214,175918,324980,949180,390435,660198,354565,989016,751320,903730,432900,725208,705960,334175,253025,825333,825407,499581,747050,235126,414057,770040,204785,171572,486058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]