SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436187 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436187 [ RunTime:0.006377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352812,911687,172333,1019338,543104,275519,170928,180199,361133,676167,418082,810107,713450,963486,406409,752834,937220,493994,373396,196856,895048,29953,208734,850690,1022129,857563,359711,27022,55027,169752,1025246,353821,832625,409846,88151,83126,470,659000,958861,890251,749925,773594,852017,425225,794500,855063,33776,242735,99319,606872,12248,774048,399777,205346,137959,886696,319316,663836,1032840,675829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]