SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102924 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102924 [ RunTime:0.005562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356864,538708,926742,812845,454952,759212,200647,284359,203623,968670,726111,789893,572379,800423,395088,368975,1047503,821749,619324,804983,13958,775208,638886,808093,70460,496672,654256,732668,417517,730558,612182,599905,696006,862163,564432,909514,216079,257784,258362,1001985,153524,865540,840132,896418,584985,228547,276075,181628,671918,851965,342015,202992,1020902,478687,955871,636485,688969,834002,546251,431039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102924 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102924 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]