SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54305 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54305 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332706,189986,482220,280175,187667,973397,465223,102947,718614,529883,1022113,402958,550672,168493,333085,493426,258502,604841,636914,353618,180057,367127,118131,93818,705071,529671,973087,242637,132210,585436,905708,446911,619995,920342,723290,220491,992839,315284,299826,1046916,915352,676982,457929,723628,51227,565140,540092,749742,1031919,253894,313982,1026951,320202,1025884,239685,574055,660712,215489,44124,464180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]