SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196838 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196838 [ RunTime:0.002844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257935,903937,809793,768634,608651,311927,452442,838098,820163,813491,49425,413942,602499,565655,156702,880954,515065,703877,235945,705561,931834,357743,689140,784956,780530,570187,1026520,868616,738854,114263,461936,394485,19142,402863,39796,4383,1046015,429573,874259,151989,54646,761064,259885,822677,724865,10955,67872,177159,617521,227992,1014815,157465,821027,455105,975393,274421,494324,907641,748230,340805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]