SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396918 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396918 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958878,1035317,155756,747132,808817,681016,516360,327272,506871,559433,788282,916766,858949,962191,106704,351208,294548,257427,334460,374598,449829,94425,515631,955317,470702,62009,131120,312855,589456,476538,1031200,396156,602591,565735,1012368,834282,438971,879900,824917,687857,365435,457935,542890,666227,397986,603291,165117,932889,984,295038,834454,158492,761236,592072,677633,891353,423043,157710,702069,713776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]