SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 839629 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 839629 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007373,857504,263061,167518,487526,385552,608927,733488,1014140,1032007,578947,953837,538350,551107,992671,409459,55696,900413,153723,998699,230081,563168,590657,729134,184298,452431,281742,993792,85684,941392,431446,1003061,715274,35917,598336,546696,853396,716608,449849,58080,27050,622620,380550,781154,512438,644044,739220,491033,983206,330489,153651,509590,11891,179019,13400,440682,702160,279703,397371,62611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 839629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 839629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]