SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315501 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315501 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571184,12029,755145,51919,149893,411407,760557,780325,385055,934019,156024,632720,808168,207140,792181,327367,287725,101643,397888,840928,429621,177270,468747,986790,16473,709685,903748,117114,415475,1012994,733683,29760,268758,477651,288269,903119,525520,389213,675612,563420,740262,58238,101785,287941,904479,61386,544705,179210,585004,968732,13168,258410,23446,754967,729349,276024,1496,553474,494846,612317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]