SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109328 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109328 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334239,665367,988171,535485,576520,189232,144227,361721,608209,564531,708826,619153,523087,26503,765316,485782,444877,381864,146497,571924,313899,320680,8279,353306,673162,565511,185713,662372,22238,526900,64343,430331,149120,365604,93663,664571,331019,957195,905376,873038,57214,159374,86658,167643,461732,380631,227033,739136,477994,788494,956120,220606,508720,161681,186824,594871,124690,687000,525738,215459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]