SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430823 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430823 [ RunTime:0.002367s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499848,634689,148862,1015244,586540,70110,480884,480856,960408,1009444,647856,972334,607191,748754,464364,510683,265439,1014657,750049,254613,164071,801779,684557,184060,113227,323763,775811,16590,436050,750457,440572,369492,430887,850199,854841,828390,580573,311537,57171,795283,279561,774786,675029,6517,357630,202199,151145,515643,874534,670589,44860,774326,667912,281334,481914,385440,683970,431409,284111,413757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]